CREATE TABLE [dbo].[T_PERSON]
(
[PERSON_ID] [bigint] NOT NULL IDENTITY(1, 1),
[PERSON_FIRST_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PERSON_LAST_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PERSON_BIRTHDATE] [date] NULL,
[PERSON_STATUS] [bit] NOT NULL,
[NATIONALITY_ID] [bigint] NULL,
[CREATE_DATE] [datetime] NOT NULL,
[DISABLE_DATE] [datetime] NULL,
[GENDER_ID] [int] NULL,
[PERSON_MIDDLE_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PERSON_LAST_NAME_2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[T_PERSON] ADD
CONSTRAINT [FK__T_PERSON__GENDER__1AD3FDA4] FOREIGN KEY ([GENDER_ID]) REFERENCES [dbo].[T_GENDER] ([GENDER_ID])
GO
ALTER TABLE [dbo].[T_PERSON] ADD CONSTRAINT [PK__T_PERSON__79BC545EE45E1C31] PRIMARY KEY CLUSTERED  ([PERSON_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_PERSON] ADD CONSTRAINT [FK_T_PERSON_T_NATIONALITY] FOREIGN KEY ([NATIONALITY_ID]) REFERENCES [dbo].[T_NATIONALITY] ([NATIONALITY_ID])
GO
